package com.blog.dao.sys.sql;


public interface UserSql2 {
	
	//分页查询所有用户
	String USER_LIST_SQL="<script> \n"
    		+"select id,username,phone,email,created,updated,openid from chb_user  where 1=1 "
    		+ "<if test='username!=null '> and username =#{username} </if>"
    		+ "<if test='phone!=null '> and phone =#{phone} </if>"
    		+"ORDER BY created ASC LIMIT #{page},#{pageSize}"
    		+ "</script> ";
	
 
	
}
